-- created by kumiler
-- on 2022/11/29 10:27
-- DESC
CREATE EXTERNAL TABLE jms_dim.dim_yl_tms_vehicle_type_base
(
    id               bigint COMMENT '车型编码',
    name             string COMMENT '车型名称',
    length           string COMMENT '车厢长度(m)',
    width            string COMMENT '车厢宽度(m)',
    height           string COMMENT '车厢高度(m)',
    weight           string COMMENT '核载质量(kg)',
    volume           string COMMENT '核定体积',
    nuclear_load_num bigint COMMENT '核载票数',
    create_by        bigint COMMENT '创建人id',
    create_by_name   string COMMENT '创建人姓名',
    create_time      timestamp COMMENT '创建时间',
    update_by        bigint COMMENT '更新人id',
    update_by_name   string COMMENT '更新人姓名',
    update_time      timestamp COMMENT '更新时间'
)
    COMMENT '车型'
stored as parquet
    LOCATION '/dw/hive/jms_dim.db/external/dim_yl_tms_vehicle_type_base'
;